package cn.bdqn.model.pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class WarrantyinfoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public WarrantyinfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andWarrantyNumberIsNull() {
            addCriterion("warranty_number is null");
            return (Criteria) this;
        }

        public Criteria andWarrantyNumberIsNotNull() {
            addCriterion("warranty_number is not null");
            return (Criteria) this;
        }

        public Criteria andWarrantyNumberEqualTo(Integer value) {
            addCriterion("warranty_number =", value, "warrantyNumber");
            return (Criteria) this;
        }

        public Criteria andWarrantyNumberNotEqualTo(Integer value) {
            addCriterion("warranty_number <>", value, "warrantyNumber");
            return (Criteria) this;
        }

        public Criteria andWarrantyNumberGreaterThan(Integer value) {
            addCriterion("warranty_number >", value, "warrantyNumber");
            return (Criteria) this;
        }

        public Criteria andWarrantyNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("warranty_number >=", value, "warrantyNumber");
            return (Criteria) this;
        }

        public Criteria andWarrantyNumberLessThan(Integer value) {
            addCriterion("warranty_number <", value, "warrantyNumber");
            return (Criteria) this;
        }

        public Criteria andWarrantyNumberLessThanOrEqualTo(Integer value) {
            addCriterion("warranty_number <=", value, "warrantyNumber");
            return (Criteria) this;
        }

        public Criteria andWarrantyNumberIn(List<Integer> values) {
            addCriterion("warranty_number in", values, "warrantyNumber");
            return (Criteria) this;
        }

        public Criteria andWarrantyNumberNotIn(List<Integer> values) {
            addCriterion("warranty_number not in", values, "warrantyNumber");
            return (Criteria) this;
        }

        public Criteria andWarrantyNumberBetween(Integer value1, Integer value2) {
            addCriterion("warranty_number between", value1, value2, "warrantyNumber");
            return (Criteria) this;
        }

        public Criteria andWarrantyNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("warranty_number not between", value1, value2, "warrantyNumber");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersIsNull() {
            addCriterion("policyholders is null");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersIsNotNull() {
            addCriterion("policyholders is not null");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersEqualTo(Integer value) {
            addCriterion("policyholders =", value, "policyholders");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersNotEqualTo(Integer value) {
            addCriterion("policyholders <>", value, "policyholders");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersGreaterThan(Integer value) {
            addCriterion("policyholders >", value, "policyholders");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersGreaterThanOrEqualTo(Integer value) {
            addCriterion("policyholders >=", value, "policyholders");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersLessThan(Integer value) {
            addCriterion("policyholders <", value, "policyholders");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersLessThanOrEqualTo(Integer value) {
            addCriterion("policyholders <=", value, "policyholders");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersIn(List<Integer> values) {
            addCriterion("policyholders in", values, "policyholders");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersNotIn(List<Integer> values) {
            addCriterion("policyholders not in", values, "policyholders");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersBetween(Integer value1, Integer value2) {
            addCriterion("policyholders between", value1, value2, "policyholders");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersNotBetween(Integer value1, Integer value2) {
            addCriterion("policyholders not between", value1, value2, "policyholders");
            return (Criteria) this;
        }

        public Criteria andRecognizeeIsNull() {
            addCriterion("recognizee is null");
            return (Criteria) this;
        }

        public Criteria andRecognizeeIsNotNull() {
            addCriterion("recognizee is not null");
            return (Criteria) this;
        }

        public Criteria andRecognizeeEqualTo(Integer value) {
            addCriterion("recognizee =", value, "recognizee");
            return (Criteria) this;
        }

        public Criteria andRecognizeeNotEqualTo(Integer value) {
            addCriterion("recognizee <>", value, "recognizee");
            return (Criteria) this;
        }

        public Criteria andRecognizeeGreaterThan(Integer value) {
            addCriterion("recognizee >", value, "recognizee");
            return (Criteria) this;
        }

        public Criteria andRecognizeeGreaterThanOrEqualTo(Integer value) {
            addCriterion("recognizee >=", value, "recognizee");
            return (Criteria) this;
        }

        public Criteria andRecognizeeLessThan(Integer value) {
            addCriterion("recognizee <", value, "recognizee");
            return (Criteria) this;
        }

        public Criteria andRecognizeeLessThanOrEqualTo(Integer value) {
            addCriterion("recognizee <=", value, "recognizee");
            return (Criteria) this;
        }

        public Criteria andRecognizeeIn(List<Integer> values) {
            addCriterion("recognizee in", values, "recognizee");
            return (Criteria) this;
        }

        public Criteria andRecognizeeNotIn(List<Integer> values) {
            addCriterion("recognizee not in", values, "recognizee");
            return (Criteria) this;
        }

        public Criteria andRecognizeeBetween(Integer value1, Integer value2) {
            addCriterion("recognizee between", value1, value2, "recognizee");
            return (Criteria) this;
        }

        public Criteria andRecognizeeNotBetween(Integer value1, Integer value2) {
            addCriterion("recognizee not between", value1, value2, "recognizee");
            return (Criteria) this;
        }

        public Criteria andPermissionDateIsNull() {
            addCriterion("permission_date is null");
            return (Criteria) this;
        }

        public Criteria andPermissionDateIsNotNull() {
            addCriterion("permission_date is not null");
            return (Criteria) this;
        }

        public Criteria andPermissionDateEqualTo(Date value) {
            addCriterionForJDBCDate("permission_date =", value, "permissionDate");
            return (Criteria) this;
        }

        public Criteria andPermissionDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("permission_date <>", value, "permissionDate");
            return (Criteria) this;
        }

        public Criteria andPermissionDateGreaterThan(Date value) {
            addCriterionForJDBCDate("permission_date >", value, "permissionDate");
            return (Criteria) this;
        }

        public Criteria andPermissionDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("permission_date >=", value, "permissionDate");
            return (Criteria) this;
        }

        public Criteria andPermissionDateLessThan(Date value) {
            addCriterionForJDBCDate("permission_date <", value, "permissionDate");
            return (Criteria) this;
        }

        public Criteria andPermissionDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("permission_date <=", value, "permissionDate");
            return (Criteria) this;
        }

        public Criteria andPermissionDateIn(List<Date> values) {
            addCriterionForJDBCDate("permission_date in", values, "permissionDate");
            return (Criteria) this;
        }

        public Criteria andPermissionDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("permission_date not in", values, "permissionDate");
            return (Criteria) this;
        }

        public Criteria andPermissionDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("permission_date between", value1, value2, "permissionDate");
            return (Criteria) this;
        }

        public Criteria andPermissionDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("permission_date not between", value1, value2, "permissionDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceBeginDateIsNull() {
            addCriterion("insurance_begin_date is null");
            return (Criteria) this;
        }

        public Criteria andInsuranceBeginDateIsNotNull() {
            addCriterion("insurance_begin_date is not null");
            return (Criteria) this;
        }

        public Criteria andInsuranceBeginDateEqualTo(Date value) {
            addCriterionForJDBCDate("insurance_begin_date =", value, "insuranceBeginDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceBeginDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("insurance_begin_date <>", value, "insuranceBeginDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceBeginDateGreaterThan(Date value) {
            addCriterionForJDBCDate("insurance_begin_date >", value, "insuranceBeginDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceBeginDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("insurance_begin_date >=", value, "insuranceBeginDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceBeginDateLessThan(Date value) {
            addCriterionForJDBCDate("insurance_begin_date <", value, "insuranceBeginDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceBeginDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("insurance_begin_date <=", value, "insuranceBeginDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceBeginDateIn(List<Date> values) {
            addCriterionForJDBCDate("insurance_begin_date in", values, "insuranceBeginDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceBeginDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("insurance_begin_date not in", values, "insuranceBeginDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceBeginDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("insurance_begin_date between", value1, value2, "insuranceBeginDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceBeginDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("insurance_begin_date not between", value1, value2, "insuranceBeginDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceEndDateIsNull() {
            addCriterion("insurance_end_date is null");
            return (Criteria) this;
        }

        public Criteria andInsuranceEndDateIsNotNull() {
            addCriterion("insurance_end_date is not null");
            return (Criteria) this;
        }

        public Criteria andInsuranceEndDateEqualTo(Date value) {
            addCriterionForJDBCDate("insurance_end_date =", value, "insuranceEndDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceEndDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("insurance_end_date <>", value, "insuranceEndDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceEndDateGreaterThan(Date value) {
            addCriterionForJDBCDate("insurance_end_date >", value, "insuranceEndDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceEndDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("insurance_end_date >=", value, "insuranceEndDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceEndDateLessThan(Date value) {
            addCriterionForJDBCDate("insurance_end_date <", value, "insuranceEndDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceEndDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("insurance_end_date <=", value, "insuranceEndDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceEndDateIn(List<Date> values) {
            addCriterionForJDBCDate("insurance_end_date in", values, "insuranceEndDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceEndDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("insurance_end_date not in", values, "insuranceEndDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceEndDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("insurance_end_date between", value1, value2, "insuranceEndDate");
            return (Criteria) this;
        }

        public Criteria andInsuranceEndDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("insurance_end_date not between", value1, value2, "insuranceEndDate");
            return (Criteria) this;
        }

        public Criteria andPaymentDateIsNull() {
            addCriterion("payment_date is null");
            return (Criteria) this;
        }

        public Criteria andPaymentDateIsNotNull() {
            addCriterion("payment_date is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentDateEqualTo(Date value) {
            addCriterionForJDBCDate("payment_date =", value, "paymentDate");
            return (Criteria) this;
        }

        public Criteria andPaymentDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("payment_date <>", value, "paymentDate");
            return (Criteria) this;
        }

        public Criteria andPaymentDateGreaterThan(Date value) {
            addCriterionForJDBCDate("payment_date >", value, "paymentDate");
            return (Criteria) this;
        }

        public Criteria andPaymentDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("payment_date >=", value, "paymentDate");
            return (Criteria) this;
        }

        public Criteria andPaymentDateLessThan(Date value) {
            addCriterionForJDBCDate("payment_date <", value, "paymentDate");
            return (Criteria) this;
        }

        public Criteria andPaymentDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("payment_date <=", value, "paymentDate");
            return (Criteria) this;
        }

        public Criteria andPaymentDateIn(List<Date> values) {
            addCriterionForJDBCDate("payment_date in", values, "paymentDate");
            return (Criteria) this;
        }

        public Criteria andPaymentDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("payment_date not in", values, "paymentDate");
            return (Criteria) this;
        }

        public Criteria andPaymentDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("payment_date between", value1, value2, "paymentDate");
            return (Criteria) this;
        }

        public Criteria andPaymentDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("payment_date not between", value1, value2, "paymentDate");
            return (Criteria) this;
        }

        public Criteria andPremiumTotalIsNull() {
            addCriterion("premium_total is null");
            return (Criteria) this;
        }

        public Criteria andPremiumTotalIsNotNull() {
            addCriterion("premium_total is not null");
            return (Criteria) this;
        }

        public Criteria andPremiumTotalEqualTo(Integer value) {
            addCriterion("premium_total =", value, "premiumTotal");
            return (Criteria) this;
        }

        public Criteria andPremiumTotalNotEqualTo(Integer value) {
            addCriterion("premium_total <>", value, "premiumTotal");
            return (Criteria) this;
        }

        public Criteria andPremiumTotalGreaterThan(Integer value) {
            addCriterion("premium_total >", value, "premiumTotal");
            return (Criteria) this;
        }

        public Criteria andPremiumTotalGreaterThanOrEqualTo(Integer value) {
            addCriterion("premium_total >=", value, "premiumTotal");
            return (Criteria) this;
        }

        public Criteria andPremiumTotalLessThan(Integer value) {
            addCriterion("premium_total <", value, "premiumTotal");
            return (Criteria) this;
        }

        public Criteria andPremiumTotalLessThanOrEqualTo(Integer value) {
            addCriterion("premium_total <=", value, "premiumTotal");
            return (Criteria) this;
        }

        public Criteria andPremiumTotalIn(List<Integer> values) {
            addCriterion("premium_total in", values, "premiumTotal");
            return (Criteria) this;
        }

        public Criteria andPremiumTotalNotIn(List<Integer> values) {
            addCriterion("premium_total not in", values, "premiumTotal");
            return (Criteria) this;
        }

        public Criteria andPremiumTotalBetween(Integer value1, Integer value2) {
            addCriterion("premium_total between", value1, value2, "premiumTotal");
            return (Criteria) this;
        }

        public Criteria andPremiumTotalNotBetween(Integer value1, Integer value2) {
            addCriterion("premium_total not between", value1, value2, "premiumTotal");
            return (Criteria) this;
        }

        public Criteria andWarrantyTypeIsNull() {
            addCriterion("warranty_type is null");
            return (Criteria) this;
        }

        public Criteria andWarrantyTypeIsNotNull() {
            addCriterion("warranty_type is not null");
            return (Criteria) this;
        }

        public Criteria andWarrantyTypeEqualTo(Integer value) {
            addCriterion("warranty_type =", value, "warrantyType");
            return (Criteria) this;
        }

        public Criteria andWarrantyTypeNotEqualTo(Integer value) {
            addCriterion("warranty_type <>", value, "warrantyType");
            return (Criteria) this;
        }

        public Criteria andWarrantyTypeGreaterThan(Integer value) {
            addCriterion("warranty_type >", value, "warrantyType");
            return (Criteria) this;
        }

        public Criteria andWarrantyTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("warranty_type >=", value, "warrantyType");
            return (Criteria) this;
        }

        public Criteria andWarrantyTypeLessThan(Integer value) {
            addCriterion("warranty_type <", value, "warrantyType");
            return (Criteria) this;
        }

        public Criteria andWarrantyTypeLessThanOrEqualTo(Integer value) {
            addCriterion("warranty_type <=", value, "warrantyType");
            return (Criteria) this;
        }

        public Criteria andWarrantyTypeIn(List<Integer> values) {
            addCriterion("warranty_type in", values, "warrantyType");
            return (Criteria) this;
        }

        public Criteria andWarrantyTypeNotIn(List<Integer> values) {
            addCriterion("warranty_type not in", values, "warrantyType");
            return (Criteria) this;
        }

        public Criteria andWarrantyTypeBetween(Integer value1, Integer value2) {
            addCriterion("warranty_type between", value1, value2, "warrantyType");
            return (Criteria) this;
        }

        public Criteria andWarrantyTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("warranty_type not between", value1, value2, "warrantyType");
            return (Criteria) this;
        }

        public Criteria andWarrantyStateIsNull() {
            addCriterion("warranty_state is null");
            return (Criteria) this;
        }

        public Criteria andWarrantyStateIsNotNull() {
            addCriterion("warranty_state is not null");
            return (Criteria) this;
        }

        public Criteria andWarrantyStateEqualTo(Integer value) {
            addCriterion("warranty_state =", value, "warrantyState");
            return (Criteria) this;
        }

        public Criteria andWarrantyStateNotEqualTo(Integer value) {
            addCriterion("warranty_state <>", value, "warrantyState");
            return (Criteria) this;
        }

        public Criteria andWarrantyStateGreaterThan(Integer value) {
            addCriterion("warranty_state >", value, "warrantyState");
            return (Criteria) this;
        }

        public Criteria andWarrantyStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("warranty_state >=", value, "warrantyState");
            return (Criteria) this;
        }

        public Criteria andWarrantyStateLessThan(Integer value) {
            addCriterion("warranty_state <", value, "warrantyState");
            return (Criteria) this;
        }

        public Criteria andWarrantyStateLessThanOrEqualTo(Integer value) {
            addCriterion("warranty_state <=", value, "warrantyState");
            return (Criteria) this;
        }

        public Criteria andWarrantyStateIn(List<Integer> values) {
            addCriterion("warranty_state in", values, "warrantyState");
            return (Criteria) this;
        }

        public Criteria andWarrantyStateNotIn(List<Integer> values) {
            addCriterion("warranty_state not in", values, "warrantyState");
            return (Criteria) this;
        }

        public Criteria andWarrantyStateBetween(Integer value1, Integer value2) {
            addCriterion("warranty_state between", value1, value2, "warrantyState");
            return (Criteria) this;
        }

        public Criteria andWarrantyStateNotBetween(Integer value1, Integer value2) {
            addCriterion("warranty_state not between", value1, value2, "warrantyState");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNumberIsNull() {
            addCriterion("cover_age_number is null");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNumberIsNotNull() {
            addCriterion("cover_age_number is not null");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNumberEqualTo(Integer value) {
            addCriterion("cover_age_number =", value, "coverAgeNumber");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNumberNotEqualTo(Integer value) {
            addCriterion("cover_age_number <>", value, "coverAgeNumber");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNumberGreaterThan(Integer value) {
            addCriterion("cover_age_number >", value, "coverAgeNumber");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("cover_age_number >=", value, "coverAgeNumber");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNumberLessThan(Integer value) {
            addCriterion("cover_age_number <", value, "coverAgeNumber");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNumberLessThanOrEqualTo(Integer value) {
            addCriterion("cover_age_number <=", value, "coverAgeNumber");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNumberIn(List<Integer> values) {
            addCriterion("cover_age_number in", values, "coverAgeNumber");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNumberNotIn(List<Integer> values) {
            addCriterion("cover_age_number not in", values, "coverAgeNumber");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNumberBetween(Integer value1, Integer value2) {
            addCriterion("cover_age_number between", value1, value2, "coverAgeNumber");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("cover_age_number not between", value1, value2, "coverAgeNumber");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNameIsNull() {
            addCriterion("cover_age_name is null");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNameIsNotNull() {
            addCriterion("cover_age_name is not null");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNameEqualTo(String value) {
            addCriterion("cover_age_name =", value, "coverAgeName");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNameNotEqualTo(String value) {
            addCriterion("cover_age_name <>", value, "coverAgeName");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNameGreaterThan(String value) {
            addCriterion("cover_age_name >", value, "coverAgeName");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNameGreaterThanOrEqualTo(String value) {
            addCriterion("cover_age_name >=", value, "coverAgeName");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNameLessThan(String value) {
            addCriterion("cover_age_name <", value, "coverAgeName");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNameLessThanOrEqualTo(String value) {
            addCriterion("cover_age_name <=", value, "coverAgeName");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNameLike(String value) {
            addCriterion("cover_age_name like", value, "coverAgeName");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNameNotLike(String value) {
            addCriterion("cover_age_name not like", value, "coverAgeName");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNameIn(List<String> values) {
            addCriterion("cover_age_name in", values, "coverAgeName");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNameNotIn(List<String> values) {
            addCriterion("cover_age_name not in", values, "coverAgeName");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNameBetween(String value1, String value2) {
            addCriterion("cover_age_name between", value1, value2, "coverAgeName");
            return (Criteria) this;
        }

        public Criteria andCoverAgeNameNotBetween(String value1, String value2) {
            addCriterion("cover_age_name not between", value1, value2, "coverAgeName");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersSumIsNull() {
            addCriterion("policyholders_sum is null");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersSumIsNotNull() {
            addCriterion("policyholders_sum is not null");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersSumEqualTo(Integer value) {
            addCriterion("policyholders_sum =", value, "policyholdersSum");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersSumNotEqualTo(Integer value) {
            addCriterion("policyholders_sum <>", value, "policyholdersSum");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersSumGreaterThan(Integer value) {
            addCriterion("policyholders_sum >", value, "policyholdersSum");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersSumGreaterThanOrEqualTo(Integer value) {
            addCriterion("policyholders_sum >=", value, "policyholdersSum");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersSumLessThan(Integer value) {
            addCriterion("policyholders_sum <", value, "policyholdersSum");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersSumLessThanOrEqualTo(Integer value) {
            addCriterion("policyholders_sum <=", value, "policyholdersSum");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersSumIn(List<Integer> values) {
            addCriterion("policyholders_sum in", values, "policyholdersSum");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersSumNotIn(List<Integer> values) {
            addCriterion("policyholders_sum not in", values, "policyholdersSum");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersSumBetween(Integer value1, Integer value2) {
            addCriterion("policyholders_sum between", value1, value2, "policyholdersSum");
            return (Criteria) this;
        }

        public Criteria andPolicyholdersSumNotBetween(Integer value1, Integer value2) {
            addCriterion("policyholders_sum not between", value1, value2, "policyholdersSum");
            return (Criteria) this;
        }

        public Criteria andPremiumSumIsNull() {
            addCriterion("premium_sum is null");
            return (Criteria) this;
        }

        public Criteria andPremiumSumIsNotNull() {
            addCriterion("premium_sum is not null");
            return (Criteria) this;
        }

        public Criteria andPremiumSumEqualTo(Integer value) {
            addCriterion("premium_sum =", value, "premiumSum");
            return (Criteria) this;
        }

        public Criteria andPremiumSumNotEqualTo(Integer value) {
            addCriterion("premium_sum <>", value, "premiumSum");
            return (Criteria) this;
        }

        public Criteria andPremiumSumGreaterThan(Integer value) {
            addCriterion("premium_sum >", value, "premiumSum");
            return (Criteria) this;
        }

        public Criteria andPremiumSumGreaterThanOrEqualTo(Integer value) {
            addCriterion("premium_sum >=", value, "premiumSum");
            return (Criteria) this;
        }

        public Criteria andPremiumSumLessThan(Integer value) {
            addCriterion("premium_sum <", value, "premiumSum");
            return (Criteria) this;
        }

        public Criteria andPremiumSumLessThanOrEqualTo(Integer value) {
            addCriterion("premium_sum <=", value, "premiumSum");
            return (Criteria) this;
        }

        public Criteria andPremiumSumIn(List<Integer> values) {
            addCriterion("premium_sum in", values, "premiumSum");
            return (Criteria) this;
        }

        public Criteria andPremiumSumNotIn(List<Integer> values) {
            addCriterion("premium_sum not in", values, "premiumSum");
            return (Criteria) this;
        }

        public Criteria andPremiumSumBetween(Integer value1, Integer value2) {
            addCriterion("premium_sum between", value1, value2, "premiumSum");
            return (Criteria) this;
        }

        public Criteria andPremiumSumNotBetween(Integer value1, Integer value2) {
            addCriterion("premium_sum not between", value1, value2, "premiumSum");
            return (Criteria) this;
        }

        public Criteria andIndemnifyMaxIsNull() {
            addCriterion("indemnify_max is null");
            return (Criteria) this;
        }

        public Criteria andIndemnifyMaxIsNotNull() {
            addCriterion("indemnify_max is not null");
            return (Criteria) this;
        }

        public Criteria andIndemnifyMaxEqualTo(Integer value) {
            addCriterion("indemnify_max =", value, "indemnifyMax");
            return (Criteria) this;
        }

        public Criteria andIndemnifyMaxNotEqualTo(Integer value) {
            addCriterion("indemnify_max <>", value, "indemnifyMax");
            return (Criteria) this;
        }

        public Criteria andIndemnifyMaxGreaterThan(Integer value) {
            addCriterion("indemnify_max >", value, "indemnifyMax");
            return (Criteria) this;
        }

        public Criteria andIndemnifyMaxGreaterThanOrEqualTo(Integer value) {
            addCriterion("indemnify_max >=", value, "indemnifyMax");
            return (Criteria) this;
        }

        public Criteria andIndemnifyMaxLessThan(Integer value) {
            addCriterion("indemnify_max <", value, "indemnifyMax");
            return (Criteria) this;
        }

        public Criteria andIndemnifyMaxLessThanOrEqualTo(Integer value) {
            addCriterion("indemnify_max <=", value, "indemnifyMax");
            return (Criteria) this;
        }

        public Criteria andIndemnifyMaxIn(List<Integer> values) {
            addCriterion("indemnify_max in", values, "indemnifyMax");
            return (Criteria) this;
        }

        public Criteria andIndemnifyMaxNotIn(List<Integer> values) {
            addCriterion("indemnify_max not in", values, "indemnifyMax");
            return (Criteria) this;
        }

        public Criteria andIndemnifyMaxBetween(Integer value1, Integer value2) {
            addCriterion("indemnify_max between", value1, value2, "indemnifyMax");
            return (Criteria) this;
        }

        public Criteria andIndemnifyMaxNotBetween(Integer value1, Integer value2) {
            addCriterion("indemnify_max not between", value1, value2, "indemnifyMax");
            return (Criteria) this;
        }

        public Criteria andEngineNumberIsNull() {
            addCriterion("engine_number is null");
            return (Criteria) this;
        }

        public Criteria andEngineNumberIsNotNull() {
            addCriterion("engine_number is not null");
            return (Criteria) this;
        }

        public Criteria andEngineNumberEqualTo(String value) {
            addCriterion("engine_number =", value, "engineNumber");
            return (Criteria) this;
        }

        public Criteria andEngineNumberNotEqualTo(String value) {
            addCriterion("engine_number <>", value, "engineNumber");
            return (Criteria) this;
        }

        public Criteria andEngineNumberGreaterThan(String value) {
            addCriterion("engine_number >", value, "engineNumber");
            return (Criteria) this;
        }

        public Criteria andEngineNumberGreaterThanOrEqualTo(String value) {
            addCriterion("engine_number >=", value, "engineNumber");
            return (Criteria) this;
        }

        public Criteria andEngineNumberLessThan(String value) {
            addCriterion("engine_number <", value, "engineNumber");
            return (Criteria) this;
        }

        public Criteria andEngineNumberLessThanOrEqualTo(String value) {
            addCriterion("engine_number <=", value, "engineNumber");
            return (Criteria) this;
        }

        public Criteria andEngineNumberLike(String value) {
            addCriterion("engine_number like", value, "engineNumber");
            return (Criteria) this;
        }

        public Criteria andEngineNumberNotLike(String value) {
            addCriterion("engine_number not like", value, "engineNumber");
            return (Criteria) this;
        }

        public Criteria andEngineNumberIn(List<String> values) {
            addCriterion("engine_number in", values, "engineNumber");
            return (Criteria) this;
        }

        public Criteria andEngineNumberNotIn(List<String> values) {
            addCriterion("engine_number not in", values, "engineNumber");
            return (Criteria) this;
        }

        public Criteria andEngineNumberBetween(String value1, String value2) {
            addCriterion("engine_number between", value1, value2, "engineNumber");
            return (Criteria) this;
        }

        public Criteria andEngineNumberNotBetween(String value1, String value2) {
            addCriterion("engine_number not between", value1, value2, "engineNumber");
            return (Criteria) this;
        }

        public Criteria andFrameNumberIsNull() {
            addCriterion("frame_number is null");
            return (Criteria) this;
        }

        public Criteria andFrameNumberIsNotNull() {
            addCriterion("frame_number is not null");
            return (Criteria) this;
        }

        public Criteria andFrameNumberEqualTo(String value) {
            addCriterion("frame_number =", value, "frameNumber");
            return (Criteria) this;
        }

        public Criteria andFrameNumberNotEqualTo(String value) {
            addCriterion("frame_number <>", value, "frameNumber");
            return (Criteria) this;
        }

        public Criteria andFrameNumberGreaterThan(String value) {
            addCriterion("frame_number >", value, "frameNumber");
            return (Criteria) this;
        }

        public Criteria andFrameNumberGreaterThanOrEqualTo(String value) {
            addCriterion("frame_number >=", value, "frameNumber");
            return (Criteria) this;
        }

        public Criteria andFrameNumberLessThan(String value) {
            addCriterion("frame_number <", value, "frameNumber");
            return (Criteria) this;
        }

        public Criteria andFrameNumberLessThanOrEqualTo(String value) {
            addCriterion("frame_number <=", value, "frameNumber");
            return (Criteria) this;
        }

        public Criteria andFrameNumberLike(String value) {
            addCriterion("frame_number like", value, "frameNumber");
            return (Criteria) this;
        }

        public Criteria andFrameNumberNotLike(String value) {
            addCriterion("frame_number not like", value, "frameNumber");
            return (Criteria) this;
        }

        public Criteria andFrameNumberIn(List<String> values) {
            addCriterion("frame_number in", values, "frameNumber");
            return (Criteria) this;
        }

        public Criteria andFrameNumberNotIn(List<String> values) {
            addCriterion("frame_number not in", values, "frameNumber");
            return (Criteria) this;
        }

        public Criteria andFrameNumberBetween(String value1, String value2) {
            addCriterion("frame_number between", value1, value2, "frameNumber");
            return (Criteria) this;
        }

        public Criteria andFrameNumberNotBetween(String value1, String value2) {
            addCriterion("frame_number not between", value1, value2, "frameNumber");
            return (Criteria) this;
        }

        public Criteria andMakeNumberIsNull() {
            addCriterion("make_number is null");
            return (Criteria) this;
        }

        public Criteria andMakeNumberIsNotNull() {
            addCriterion("make_number is not null");
            return (Criteria) this;
        }

        public Criteria andMakeNumberEqualTo(String value) {
            addCriterion("make_number =", value, "makeNumber");
            return (Criteria) this;
        }

        public Criteria andMakeNumberNotEqualTo(String value) {
            addCriterion("make_number <>", value, "makeNumber");
            return (Criteria) this;
        }

        public Criteria andMakeNumberGreaterThan(String value) {
            addCriterion("make_number >", value, "makeNumber");
            return (Criteria) this;
        }

        public Criteria andMakeNumberGreaterThanOrEqualTo(String value) {
            addCriterion("make_number >=", value, "makeNumber");
            return (Criteria) this;
        }

        public Criteria andMakeNumberLessThan(String value) {
            addCriterion("make_number <", value, "makeNumber");
            return (Criteria) this;
        }

        public Criteria andMakeNumberLessThanOrEqualTo(String value) {
            addCriterion("make_number <=", value, "makeNumber");
            return (Criteria) this;
        }

        public Criteria andMakeNumberLike(String value) {
            addCriterion("make_number like", value, "makeNumber");
            return (Criteria) this;
        }

        public Criteria andMakeNumberNotLike(String value) {
            addCriterion("make_number not like", value, "makeNumber");
            return (Criteria) this;
        }

        public Criteria andMakeNumberIn(List<String> values) {
            addCriterion("make_number in", values, "makeNumber");
            return (Criteria) this;
        }

        public Criteria andMakeNumberNotIn(List<String> values) {
            addCriterion("make_number not in", values, "makeNumber");
            return (Criteria) this;
        }

        public Criteria andMakeNumberBetween(String value1, String value2) {
            addCriterion("make_number between", value1, value2, "makeNumber");
            return (Criteria) this;
        }

        public Criteria andMakeNumberNotBetween(String value1, String value2) {
            addCriterion("make_number not between", value1, value2, "makeNumber");
            return (Criteria) this;
        }

        public Criteria andLicenseNumberIsNull() {
            addCriterion("license_number is null");
            return (Criteria) this;
        }

        public Criteria andLicenseNumberIsNotNull() {
            addCriterion("license_number is not null");
            return (Criteria) this;
        }

        public Criteria andLicenseNumberEqualTo(String value) {
            addCriterion("license_number =", value, "licenseNumber");
            return (Criteria) this;
        }

        public Criteria andLicenseNumberNotEqualTo(String value) {
            addCriterion("license_number <>", value, "licenseNumber");
            return (Criteria) this;
        }

        public Criteria andLicenseNumberGreaterThan(String value) {
            addCriterion("license_number >", value, "licenseNumber");
            return (Criteria) this;
        }

        public Criteria andLicenseNumberGreaterThanOrEqualTo(String value) {
            addCriterion("license_number >=", value, "licenseNumber");
            return (Criteria) this;
        }

        public Criteria andLicenseNumberLessThan(String value) {
            addCriterion("license_number <", value, "licenseNumber");
            return (Criteria) this;
        }

        public Criteria andLicenseNumberLessThanOrEqualTo(String value) {
            addCriterion("license_number <=", value, "licenseNumber");
            return (Criteria) this;
        }

        public Criteria andLicenseNumberLike(String value) {
            addCriterion("license_number like", value, "licenseNumber");
            return (Criteria) this;
        }

        public Criteria andLicenseNumberNotLike(String value) {
            addCriterion("license_number not like", value, "licenseNumber");
            return (Criteria) this;
        }

        public Criteria andLicenseNumberIn(List<String> values) {
            addCriterion("license_number in", values, "licenseNumber");
            return (Criteria) this;
        }

        public Criteria andLicenseNumberNotIn(List<String> values) {
            addCriterion("license_number not in", values, "licenseNumber");
            return (Criteria) this;
        }

        public Criteria andLicenseNumberBetween(String value1, String value2) {
            addCriterion("license_number between", value1, value2, "licenseNumber");
            return (Criteria) this;
        }

        public Criteria andLicenseNumberNotBetween(String value1, String value2) {
            addCriterion("license_number not between", value1, value2, "licenseNumber");
            return (Criteria) this;
        }

        public Criteria andCarColorIsNull() {
            addCriterion("car_color is null");
            return (Criteria) this;
        }

        public Criteria andCarColorIsNotNull() {
            addCriterion("car_color is not null");
            return (Criteria) this;
        }

        public Criteria andCarColorEqualTo(String value) {
            addCriterion("car_color =", value, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorNotEqualTo(String value) {
            addCriterion("car_color <>", value, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorGreaterThan(String value) {
            addCriterion("car_color >", value, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorGreaterThanOrEqualTo(String value) {
            addCriterion("car_color >=", value, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorLessThan(String value) {
            addCriterion("car_color <", value, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorLessThanOrEqualTo(String value) {
            addCriterion("car_color <=", value, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorLike(String value) {
            addCriterion("car_color like", value, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorNotLike(String value) {
            addCriterion("car_color not like", value, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorIn(List<String> values) {
            addCriterion("car_color in", values, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorNotIn(List<String> values) {
            addCriterion("car_color not in", values, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorBetween(String value1, String value2) {
            addCriterion("car_color between", value1, value2, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorNotBetween(String value1, String value2) {
            addCriterion("car_color not between", value1, value2, "carColor");
            return (Criteria) this;
        }

        public Criteria andMotorTypeIsNull() {
            addCriterion("motor_type is null");
            return (Criteria) this;
        }

        public Criteria andMotorTypeIsNotNull() {
            addCriterion("motor_type is not null");
            return (Criteria) this;
        }

        public Criteria andMotorTypeEqualTo(Integer value) {
            addCriterion("motor_type =", value, "motorType");
            return (Criteria) this;
        }

        public Criteria andMotorTypeNotEqualTo(Integer value) {
            addCriterion("motor_type <>", value, "motorType");
            return (Criteria) this;
        }

        public Criteria andMotorTypeGreaterThan(Integer value) {
            addCriterion("motor_type >", value, "motorType");
            return (Criteria) this;
        }

        public Criteria andMotorTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("motor_type >=", value, "motorType");
            return (Criteria) this;
        }

        public Criteria andMotorTypeLessThan(Integer value) {
            addCriterion("motor_type <", value, "motorType");
            return (Criteria) this;
        }

        public Criteria andMotorTypeLessThanOrEqualTo(Integer value) {
            addCriterion("motor_type <=", value, "motorType");
            return (Criteria) this;
        }

        public Criteria andMotorTypeIn(List<Integer> values) {
            addCriterion("motor_type in", values, "motorType");
            return (Criteria) this;
        }

        public Criteria andMotorTypeNotIn(List<Integer> values) {
            addCriterion("motor_type not in", values, "motorType");
            return (Criteria) this;
        }

        public Criteria andMotorTypeBetween(Integer value1, Integer value2) {
            addCriterion("motor_type between", value1, value2, "motorType");
            return (Criteria) this;
        }

        public Criteria andMotorTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("motor_type not between", value1, value2, "motorType");
            return (Criteria) this;
        }

        public Criteria andNatureIsNull() {
            addCriterion("nature is null");
            return (Criteria) this;
        }

        public Criteria andNatureIsNotNull() {
            addCriterion("nature is not null");
            return (Criteria) this;
        }

        public Criteria andNatureEqualTo(String value) {
            addCriterion("nature =", value, "nature");
            return (Criteria) this;
        }

        public Criteria andNatureNotEqualTo(String value) {
            addCriterion("nature <>", value, "nature");
            return (Criteria) this;
        }

        public Criteria andNatureGreaterThan(String value) {
            addCriterion("nature >", value, "nature");
            return (Criteria) this;
        }

        public Criteria andNatureGreaterThanOrEqualTo(String value) {
            addCriterion("nature >=", value, "nature");
            return (Criteria) this;
        }

        public Criteria andNatureLessThan(String value) {
            addCriterion("nature <", value, "nature");
            return (Criteria) this;
        }

        public Criteria andNatureLessThanOrEqualTo(String value) {
            addCriterion("nature <=", value, "nature");
            return (Criteria) this;
        }

        public Criteria andNatureLike(String value) {
            addCriterion("nature like", value, "nature");
            return (Criteria) this;
        }

        public Criteria andNatureNotLike(String value) {
            addCriterion("nature not like", value, "nature");
            return (Criteria) this;
        }

        public Criteria andNatureIn(List<String> values) {
            addCriterion("nature in", values, "nature");
            return (Criteria) this;
        }

        public Criteria andNatureNotIn(List<String> values) {
            addCriterion("nature not in", values, "nature");
            return (Criteria) this;
        }

        public Criteria andNatureBetween(String value1, String value2) {
            addCriterion("nature between", value1, value2, "nature");
            return (Criteria) this;
        }

        public Criteria andNatureNotBetween(String value1, String value2) {
            addCriterion("nature not between", value1, value2, "nature");
            return (Criteria) this;
        }

        public Criteria andMintedDateIsNull() {
            addCriterion("minted_date is null");
            return (Criteria) this;
        }

        public Criteria andMintedDateIsNotNull() {
            addCriterion("minted_date is not null");
            return (Criteria) this;
        }

        public Criteria andMintedDateEqualTo(Date value) {
            addCriterionForJDBCDate("minted_date =", value, "mintedDate");
            return (Criteria) this;
        }

        public Criteria andMintedDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("minted_date <>", value, "mintedDate");
            return (Criteria) this;
        }

        public Criteria andMintedDateGreaterThan(Date value) {
            addCriterionForJDBCDate("minted_date >", value, "mintedDate");
            return (Criteria) this;
        }

        public Criteria andMintedDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("minted_date >=", value, "mintedDate");
            return (Criteria) this;
        }

        public Criteria andMintedDateLessThan(Date value) {
            addCriterionForJDBCDate("minted_date <", value, "mintedDate");
            return (Criteria) this;
        }

        public Criteria andMintedDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("minted_date <=", value, "mintedDate");
            return (Criteria) this;
        }

        public Criteria andMintedDateIn(List<Date> values) {
            addCriterionForJDBCDate("minted_date in", values, "mintedDate");
            return (Criteria) this;
        }

        public Criteria andMintedDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("minted_date not in", values, "mintedDate");
            return (Criteria) this;
        }

        public Criteria andMintedDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("minted_date between", value1, value2, "mintedDate");
            return (Criteria) this;
        }

        public Criteria andMintedDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("minted_date not between", value1, value2, "mintedDate");
            return (Criteria) this;
        }

        public Criteria andCustomersSumIsNull() {
            addCriterion("customers_sum is null");
            return (Criteria) this;
        }

        public Criteria andCustomersSumIsNotNull() {
            addCriterion("customers_sum is not null");
            return (Criteria) this;
        }

        public Criteria andCustomersSumEqualTo(Integer value) {
            addCriterion("customers_sum =", value, "customersSum");
            return (Criteria) this;
        }

        public Criteria andCustomersSumNotEqualTo(Integer value) {
            addCriterion("customers_sum <>", value, "customersSum");
            return (Criteria) this;
        }

        public Criteria andCustomersSumGreaterThan(Integer value) {
            addCriterion("customers_sum >", value, "customersSum");
            return (Criteria) this;
        }

        public Criteria andCustomersSumGreaterThanOrEqualTo(Integer value) {
            addCriterion("customers_sum >=", value, "customersSum");
            return (Criteria) this;
        }

        public Criteria andCustomersSumLessThan(Integer value) {
            addCriterion("customers_sum <", value, "customersSum");
            return (Criteria) this;
        }

        public Criteria andCustomersSumLessThanOrEqualTo(Integer value) {
            addCriterion("customers_sum <=", value, "customersSum");
            return (Criteria) this;
        }

        public Criteria andCustomersSumIn(List<Integer> values) {
            addCriterion("customers_sum in", values, "customersSum");
            return (Criteria) this;
        }

        public Criteria andCustomersSumNotIn(List<Integer> values) {
            addCriterion("customers_sum not in", values, "customersSum");
            return (Criteria) this;
        }

        public Criteria andCustomersSumBetween(Integer value1, Integer value2) {
            addCriterion("customers_sum between", value1, value2, "customersSum");
            return (Criteria) this;
        }

        public Criteria andCustomersSumNotBetween(Integer value1, Integer value2) {
            addCriterion("customers_sum not between", value1, value2, "customersSum");
            return (Criteria) this;
        }

        public Criteria andSailNumberIsNull() {
            addCriterion("sail_number is null");
            return (Criteria) this;
        }

        public Criteria andSailNumberIsNotNull() {
            addCriterion("sail_number is not null");
            return (Criteria) this;
        }

        public Criteria andSailNumberEqualTo(String value) {
            addCriterion("sail_number =", value, "sailNumber");
            return (Criteria) this;
        }

        public Criteria andSailNumberNotEqualTo(String value) {
            addCriterion("sail_number <>", value, "sailNumber");
            return (Criteria) this;
        }

        public Criteria andSailNumberGreaterThan(String value) {
            addCriterion("sail_number >", value, "sailNumber");
            return (Criteria) this;
        }

        public Criteria andSailNumberGreaterThanOrEqualTo(String value) {
            addCriterion("sail_number >=", value, "sailNumber");
            return (Criteria) this;
        }

        public Criteria andSailNumberLessThan(String value) {
            addCriterion("sail_number <", value, "sailNumber");
            return (Criteria) this;
        }

        public Criteria andSailNumberLessThanOrEqualTo(String value) {
            addCriterion("sail_number <=", value, "sailNumber");
            return (Criteria) this;
        }

        public Criteria andSailNumberLike(String value) {
            addCriterion("sail_number like", value, "sailNumber");
            return (Criteria) this;
        }

        public Criteria andSailNumberNotLike(String value) {
            addCriterion("sail_number not like", value, "sailNumber");
            return (Criteria) this;
        }

        public Criteria andSailNumberIn(List<String> values) {
            addCriterion("sail_number in", values, "sailNumber");
            return (Criteria) this;
        }

        public Criteria andSailNumberNotIn(List<String> values) {
            addCriterion("sail_number not in", values, "sailNumber");
            return (Criteria) this;
        }

        public Criteria andSailNumberBetween(String value1, String value2) {
            addCriterion("sail_number between", value1, value2, "sailNumber");
            return (Criteria) this;
        }

        public Criteria andSailNumberNotBetween(String value1, String value2) {
            addCriterion("sail_number not between", value1, value2, "sailNumber");
            return (Criteria) this;
        }

        public Criteria andCarOwnerNameIsNull() {
            addCriterion("car_owner_name is null");
            return (Criteria) this;
        }

        public Criteria andCarOwnerNameIsNotNull() {
            addCriterion("car_owner_name is not null");
            return (Criteria) this;
        }

        public Criteria andCarOwnerNameEqualTo(String value) {
            addCriterion("car_owner_name =", value, "carOwnerName");
            return (Criteria) this;
        }

        public Criteria andCarOwnerNameNotEqualTo(String value) {
            addCriterion("car_owner_name <>", value, "carOwnerName");
            return (Criteria) this;
        }

        public Criteria andCarOwnerNameGreaterThan(String value) {
            addCriterion("car_owner_name >", value, "carOwnerName");
            return (Criteria) this;
        }

        public Criteria andCarOwnerNameGreaterThanOrEqualTo(String value) {
            addCriterion("car_owner_name >=", value, "carOwnerName");
            return (Criteria) this;
        }

        public Criteria andCarOwnerNameLessThan(String value) {
            addCriterion("car_owner_name <", value, "carOwnerName");
            return (Criteria) this;
        }

        public Criteria andCarOwnerNameLessThanOrEqualTo(String value) {
            addCriterion("car_owner_name <=", value, "carOwnerName");
            return (Criteria) this;
        }

        public Criteria andCarOwnerNameLike(String value) {
            addCriterion("car_owner_name like", value, "carOwnerName");
            return (Criteria) this;
        }

        public Criteria andCarOwnerNameNotLike(String value) {
            addCriterion("car_owner_name not like", value, "carOwnerName");
            return (Criteria) this;
        }

        public Criteria andCarOwnerNameIn(List<String> values) {
            addCriterion("car_owner_name in", values, "carOwnerName");
            return (Criteria) this;
        }

        public Criteria andCarOwnerNameNotIn(List<String> values) {
            addCriterion("car_owner_name not in", values, "carOwnerName");
            return (Criteria) this;
        }

        public Criteria andCarOwnerNameBetween(String value1, String value2) {
            addCriterion("car_owner_name between", value1, value2, "carOwnerName");
            return (Criteria) this;
        }

        public Criteria andCarOwnerNameNotBetween(String value1, String value2) {
            addCriterion("car_owner_name not between", value1, value2, "carOwnerName");
            return (Criteria) this;
        }

        public Criteria andVpDollarIsNull() {
            addCriterion("vp_dollar is null");
            return (Criteria) this;
        }

        public Criteria andVpDollarIsNotNull() {
            addCriterion("vp_dollar is not null");
            return (Criteria) this;
        }

        public Criteria andVpDollarEqualTo(Integer value) {
            addCriterion("vp_dollar =", value, "vpDollar");
            return (Criteria) this;
        }

        public Criteria andVpDollarNotEqualTo(Integer value) {
            addCriterion("vp_dollar <>", value, "vpDollar");
            return (Criteria) this;
        }

        public Criteria andVpDollarGreaterThan(Integer value) {
            addCriterion("vp_dollar >", value, "vpDollar");
            return (Criteria) this;
        }

        public Criteria andVpDollarGreaterThanOrEqualTo(Integer value) {
            addCriterion("vp_dollar >=", value, "vpDollar");
            return (Criteria) this;
        }

        public Criteria andVpDollarLessThan(Integer value) {
            addCriterion("vp_dollar <", value, "vpDollar");
            return (Criteria) this;
        }

        public Criteria andVpDollarLessThanOrEqualTo(Integer value) {
            addCriterion("vp_dollar <=", value, "vpDollar");
            return (Criteria) this;
        }

        public Criteria andVpDollarIn(List<Integer> values) {
            addCriterion("vp_dollar in", values, "vpDollar");
            return (Criteria) this;
        }

        public Criteria andVpDollarNotIn(List<Integer> values) {
            addCriterion("vp_dollar not in", values, "vpDollar");
            return (Criteria) this;
        }

        public Criteria andVpDollarBetween(Integer value1, Integer value2) {
            addCriterion("vp_dollar between", value1, value2, "vpDollar");
            return (Criteria) this;
        }

        public Criteria andVpDollarNotBetween(Integer value1, Integer value2) {
            addCriterion("vp_dollar not between", value1, value2, "vpDollar");
            return (Criteria) this;
        }

        public Criteria andRegisterDateIsNull() {
            addCriterion("register_date is null");
            return (Criteria) this;
        }

        public Criteria andRegisterDateIsNotNull() {
            addCriterion("register_date is not null");
            return (Criteria) this;
        }

        public Criteria andRegisterDateEqualTo(Date value) {
            addCriterionForJDBCDate("register_date =", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("register_date <>", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateGreaterThan(Date value) {
            addCriterionForJDBCDate("register_date >", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("register_date >=", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateLessThan(Date value) {
            addCriterionForJDBCDate("register_date <", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("register_date <=", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateIn(List<Date> values) {
            addCriterionForJDBCDate("register_date in", values, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("register_date not in", values, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("register_date between", value1, value2, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("register_date not between", value1, value2, "registerDate");
            return (Criteria) this;
        }

        public Criteria andPlacemanLengthIsNull() {
            addCriterion("placeman_length is null");
            return (Criteria) this;
        }

        public Criteria andPlacemanLengthIsNotNull() {
            addCriterion("placeman_length is not null");
            return (Criteria) this;
        }

        public Criteria andPlacemanLengthEqualTo(Integer value) {
            addCriterion("placeman_length =", value, "placemanLength");
            return (Criteria) this;
        }

        public Criteria andPlacemanLengthNotEqualTo(Integer value) {
            addCriterion("placeman_length <>", value, "placemanLength");
            return (Criteria) this;
        }

        public Criteria andPlacemanLengthGreaterThan(Integer value) {
            addCriterion("placeman_length >", value, "placemanLength");
            return (Criteria) this;
        }

        public Criteria andPlacemanLengthGreaterThanOrEqualTo(Integer value) {
            addCriterion("placeman_length >=", value, "placemanLength");
            return (Criteria) this;
        }

        public Criteria andPlacemanLengthLessThan(Integer value) {
            addCriterion("placeman_length <", value, "placemanLength");
            return (Criteria) this;
        }

        public Criteria andPlacemanLengthLessThanOrEqualTo(Integer value) {
            addCriterion("placeman_length <=", value, "placemanLength");
            return (Criteria) this;
        }

        public Criteria andPlacemanLengthIn(List<Integer> values) {
            addCriterion("placeman_length in", values, "placemanLength");
            return (Criteria) this;
        }

        public Criteria andPlacemanLengthNotIn(List<Integer> values) {
            addCriterion("placeman_length not in", values, "placemanLength");
            return (Criteria) this;
        }

        public Criteria andPlacemanLengthBetween(Integer value1, Integer value2) {
            addCriterion("placeman_length between", value1, value2, "placemanLength");
            return (Criteria) this;
        }

        public Criteria andPlacemanLengthNotBetween(Integer value1, Integer value2) {
            addCriterion("placeman_length not between", value1, value2, "placemanLength");
            return (Criteria) this;
        }

        public Criteria andMileageIsNull() {
            addCriterion("mileage is null");
            return (Criteria) this;
        }

        public Criteria andMileageIsNotNull() {
            addCriterion("mileage is not null");
            return (Criteria) this;
        }

        public Criteria andMileageEqualTo(Integer value) {
            addCriterion("mileage =", value, "mileage");
            return (Criteria) this;
        }

        public Criteria andMileageNotEqualTo(Integer value) {
            addCriterion("mileage <>", value, "mileage");
            return (Criteria) this;
        }

        public Criteria andMileageGreaterThan(Integer value) {
            addCriterion("mileage >", value, "mileage");
            return (Criteria) this;
        }

        public Criteria andMileageGreaterThanOrEqualTo(Integer value) {
            addCriterion("mileage >=", value, "mileage");
            return (Criteria) this;
        }

        public Criteria andMileageLessThan(Integer value) {
            addCriterion("mileage <", value, "mileage");
            return (Criteria) this;
        }

        public Criteria andMileageLessThanOrEqualTo(Integer value) {
            addCriterion("mileage <=", value, "mileage");
            return (Criteria) this;
        }

        public Criteria andMileageIn(List<Integer> values) {
            addCriterion("mileage in", values, "mileage");
            return (Criteria) this;
        }

        public Criteria andMileageNotIn(List<Integer> values) {
            addCriterion("mileage not in", values, "mileage");
            return (Criteria) this;
        }

        public Criteria andMileageBetween(Integer value1, Integer value2) {
            addCriterion("mileage between", value1, value2, "mileage");
            return (Criteria) this;
        }

        public Criteria andMileageNotBetween(Integer value1, Integer value2) {
            addCriterion("mileage not between", value1, value2, "mileage");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}